CREATE PROCEDURE [dbo].[categories_insert]
    @name nvarchar(256)
AS
INSERT INTO [dbo].[Categories]
(Name)VALUES(@name)
declare @categoryId int = @@IDENTITY

SELECT
    [CategoryId],
    [Name]
FROM [dbo].[Categories] 
WHERE
    Categories.[CategoryId]=@categoryId
RETURN 0
